report/notes/sharding proxy single database single table.html (60 lines of code) (raw):
<!doctype html>
<html>
<head>
<meta charset='UTF-8'><meta name='viewport' content='width=device-width initial-scale=1'>
<title>sharding proxy single database single table</title></head>
<body><p><img src='../scenario_1/select_single.png' alt='insert_single' referrerPolicy='no-referrer' /></p>
<pre><code>Comparative Version:
Mysql: 5.1.42(red curve)
ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
Table Number: Multi table(e.g:t_test_0,t_test_1......)
Data Volume: 200w
Axis:
X: (TEST TIMES)/DAY
Y: TPS
Scene Description：This is a SingleDataBase and SingleTable model.We used id, k, c, pad fields in the table.Database fragmentation key is ID, Table fragmentation key is K.
Sql Example: SELECT id,k FROM t_test WHERE id = # AND k = #
Comparative type: SELECT
</code></pre>
<p><img src='../scenario_1/update_single.png' alt='update_single' referrerPolicy='no-referrer' /></p>
<pre><code>Comparative Version:
Mysql: 5.1.42(red curve)
ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
Table Number: Multi table(e.g:t_test_0,t_test_1......)
Data Volume: 200w
Axis:
X: (TEST TIMES)/DAY
Y: TPS
Scene Description：This is a SingleDataBase and SingleTable model.We used id, k, c, pad fields in the table.Database fragmentation key is ID, Table fragmentation key is K.
Sql Example: UPDATE t_test SET pad = # WHERE id = # AND k = #
Comparative type: UPDATE
</code></pre>
<p><img src='../scenario_1/delete_single.png' alt='delete_single' referrerPolicy='no-referrer' /></p>
<pre><code>Comparative Version:
Mysql: 5.1.42(red curve)
ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
Table Number: Multi table(e.g:t_test_0,t_test_1......)
Data Volume: 200w
Axis:
X: (TEST TIMES)/DAY
Y: TPS
Scene Description：This is a SingleDataBase and SingleTable model.We used id, k, c, pad fields in the table.Database fragmentation key is ID, Table fragmentation key is K.
Sql Example: DELETE FROM t_test WHERE id = # AND k = #
Comparative type: DELETE
</code></pre>
<p><img src='../scenario_1/insert_single.png' alt='insert_single' referrerPolicy='no-referrer' /></p>
<pre><code>Comparative Version:
Mysql: 5.1.42(red curve)
ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
Table Number: Multi table(e.g:t_test_0,t_test_1......)
Data Volume: 200w
Axis:
X: (TEST TIMES)/DAY
Y: TPS
Scene Description：This is a SingleDataBase and SingleTable model.We used id, k, c, pad fields in the table.Database fragmentation key is ID, Table fragmentation key is K.
Sql Example: INSERT INTO t_test(k,c,pad) VALUES(#,#,#)
Comparative type: INSERT
</code></pre>
<p> </p>
</body>
</html